Micron Document
Gemini Proxy

Home Proxy Menu Search Engine
Back

gemi.dev gemi.dev/gemini-mailing-list/001068.gmi
[users] Gemini "Server of the Day" & database
* 📧 Messages: 2
* 🗣️ Authors: 2
* đź“… First Message: 2021-11-05 08:27
* đź“… Last Message: 2021-11-05 08:57
1. Anna “CyberTailor” (cyber (a) sysrq.in)
* đź“… Sent: 2021-11-05 08:27
* 📧 Message 1 of 2

I'm glad to announce this useless thing!

`=`F19f`[gemini://sotd.sysrq.in`:/page/rgproxy.mu`resultat=sotd.sysrq.in/|backurl=gemi.dev/gemini-mailing-list/001068.gmi]`f``

It advertises randomly chosen gemini server for a day.
Also there's a list of all servers and SQLite database.

And speaking of database, it can be automatically updated by email.
`=`F19f`[gemini://sotd.sysrq.in/info/README.gmi`:/page/rgproxy.mu`resultat=sotd.sysrq.in/info/README.gmi|backurl=gemi.dev/gemini-mailing-list/001068.gmi]`f``

That's all.

(By the way, how to fix this error with PRAGMA foreign_keys:
foreign key mismatch - "server_features" referencing "servers")
Link to individual message.
2. Teito Klien (opensource (a) teitoklien.com)
* Subject Changed! New Subject: Re: [users] Gemini "Server of the Day" & database
* đź“… Sent: 2021-11-05 08:57
* 📧 Message 2 of 2

Hi anna,
Cool project !

The foreign key mismatch in your sql table is most likely because, the key
, your foreign key is referencing to , is not guaranteed to be unique.

Which means its neither the primary key , nor  having the unique
constraint which is necessary for the parent key referenced in a foreign key in sqlite3.

For more info, refer to
https://www.sqlite.org/foreignkeys.html#fk_indexes

To help more, I would need to know your dbschema.

But hopefully the docs linked above, should help you solve your problem

Have a great day !
Regards,
Klien
On 5 Nov 2021, 1:58 PM +0530, Anna “CyberTailor” <cyber@sysrq.in>, wrote:
`! I'm glad to announce this useless thing!`!
`!`!
`! => gemini://sotd.sysrq.in`!
`!`!
`! It advertises randomly chosen gemini server for a day.`!
`! Also there's a list of all servers and SQLite database.`!
`!`!
`! And speaking of database, it can be automatically updated by email.`!
`! => gemini://sotd.sysrq.in/info/README.gmi`!
`!`!
`! That's all.`!
`!`!
`! (By the way, how to fix this error with PRAGMA foreign_keys:`!
`! foreign key mismatch - "server_features" referencing "servers")`!
Link to individual message.
---
Previous Thread: RE: RE: Rethinking the link line
Next Thread: {ANN} Specification update

you're on gemi.dev/gemini-mailing-list/001068.gmi